CREATE EXTERNAL TABLE jms_dm.dm_download_repeat_outscan_detail_dt(
  waybill_no string COMMENT '单号', 
  agent_code string COMMENT '代理区code', 
  agent_name string COMMENT '代理区name', 
  scan_time timestamp COMMENT '扫描时间', 
  scan_type string COMMENT '扫描类型', 
  site_code string COMMENT '扫描网点', 
  site_name string COMMENT '扫描网点名称', 
  store_code string COMMENT '门店编码', 
  store_name string COMMENT '门店名称', 
  is_work_order tinyint COMMENT '是否客诉 1是', 
  is_flas_sign tinyint COMMENT '是否虚假签收 1是', 
  apply_type_code tinyint COMMENT '退转类型4退件5转寄', 
  is_sign_del tinyint COMMENT '是否签收删除1是', 
  reback_apply_time timestamp COMMENT '退转申请时间', 
  date_time date COMMENT '查询时间')
COMMENT '下载中心_重复出库明细'
PARTITIONED BY ( 
  dt string COMMENT '日期分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_download_repeat_outscan_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
